<html><head><title>Turn off the like optimization for ad-hoc queries using local variables</title><meta name="HandheldFriendly" content="True"></head><body>Turn off the like optimization for ad-hoc queries using local variables<br><br><b>dbcc</b> {<b>traceon</b> | <b>traceoff</b>} (<b>324</b>)</body></html>